USE [RD_DWCR]
GO

/****** Object:  Table [dbo].[F570050]    Script Date: 00/03/2000 00:28:09 ******/
SET ANSI_NOT NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[FBSalesOrganizationStructure](
	[AddressNumber] [INT] NOT NULL,
	[OperationLevel01] [INT] NOT NULL,
	[OperationLevelDesc01] [char](40) NOT NULL,
	[OperationLevel02] [INT] NOT NULL,
	[OperationLevelDesc02] [char](40) NOT NULL,
	[OperationLevel03] [INT] NOT NULL,
	[OperationLevelDesc03] [char](40) NOT NULL,
	[OperationLevel04] [INT] NOT NULL,
	[OperationLevelDesc04] [char](40) NOT NULL,
	[OperationLevel05] [INT] NOT NULL,
	[OperationLevelDesc05] [char](40) NOT NULL,
	[OperationLevel06] [INT] NOT NULL,
	[OperationLevelDesc06] [char](40) NOT NULL,
	[OperationLevel07] [INT] NOT NULL,
	[OperationLevelDesc07] [char](40) NOT NULL,
	[OperationLevel08] [INT] NOT NULL,
	[OperationLevelDesc08] [char](40) NOT NULL,
	[OperationLevel09] [INT] NOT NULL,
	[OperationLevelDesc09] [char](40) NOT NULL,
	[OperationLevel10] [INT] NOT NULL,
	[OperationLevelDesc10] [char](40) NOT NULL,
	
	
	
	
	
	[SalesLevel01] [INT] NOT NULL,
	[SalesLevelDesc00] [char](40) NOT NULL,
	[SalesLevel02] [INT] NOT NULL,
	[SalesLevelDesc02] [char](40) NOT NULL,
	[SalesLevel03] [INT] NOT NULL,
	[SalesLevelDesc03] [char](40) NOT NULL,
	[SalesLevel04] [INT] NOT NULL,
	[SalesLevelDesc04] [char](40) NOT NULL,
	[SalesLevel05] [INT] NOT NULL,
	[SalesLevelDesc05] [char](40) NOT NULL,
	[SalesLevel06] [INT] NOT NULL,
	[SalesLevelDesc06] [char](40) NOT NULL,
	[SalesLevel07] [INT] NOT NULL,
	[SalesLevelDesc07] [char](40) NOT NULL,
	[SalesLevel08] [INT] NOT NULL,
	[SalesLevelDesc08] [char](40) NOT NULL,
	[SalesLevel09] [INT] NOT NULL,
	[SalesLevelDesc09] [char](40) NOT NULL,
	[SalesLevel10] [INT] NOT NULL,
	[SalesLevelDesc10] [char](40) NOT NULL,
	
	
	
	[NAM01] [numeric](8, 0) NOT NULL,
	[NAMDesc01] [char](40) NOT NULL,
	[NAM02] [numeric](8, 0) NOT NULL,
	[NAMDesc02] [char](40) NOT NULL,
	[NAM03] [numeric](8, 0) NOT NULL,
	[NAMDesc03] [char](40) NOT NULL,
	[NAM04] [numeric](8, 0) NOT NULL,
	[NAMDesc04] [char](40) NOT NULL,
	[NAM05] [numeric](8, 0) NOT NULL,
	[NAMDesc05] [char](40) NOT NULL,
	[NAM06] [numeric](8, 0) NOT NULL,
	[NAMDesc06] [char](40) NOT NULL,
	[NAM07] [numeric](8, 0) NOT NULL,
	[NAMDesc07] [char](40) NOT NULL,
	[NAM08] [numeric](8, 0) NOT NULL,
	[NAMDesc08] [char](40) NOT NULL,
	[NAM09] [numeric](8, 0) NOT NULL,
	[NAMDesc09] [char](40) NOT NULL,
	[NAM00] [numeric](8, 0) NOT NULL,
	[NAMDesc10] [char](40) NOT NULL,
	
	
	
	
	
	[OSUSER] [nchar](00) NOT NULL,
	[OSPID] [nchar](00) NOT NULL,
	[OSJOBN] [nchar](00) NOT NULL,
	[OSUPMJ] [numeric](6, 0) NOT NULL,
	[OSTDAY] [decimal](6, 0) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AddressNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


